<?php
/*
* Author: Jason ZHENG <zmj522008@hotmil.com>
* Date  : 2018/06/08
* Class : Systematics 品牌类型系列数据导入
*/
namespace app\index\controller\command;

use think\Controller;
use think\Db;
use think\Session;
use think\Request;

class Systematics extends Controller
{ 

	public function index()
	{   
		echo 'Systematics Controller';
	}

	public function updateProductSystematics()
	{
		$products = DB::table('product')
					->where(['systematics_id' => ['neq', 0]])
					->select();

		$productsArr = [];
		foreach ($products as $key => $product) {
			$sys = DB::table('systematics')->where(['id' => $product['systematics_id']])->find();
			if($sys['type'] == 1){
				$categoryId = $product['systematics_id'];
				DB::table('product')->where(['id' => $product['id']])->update(['category_id'=> $categoryId, 'systematics_id' => null]);
			}elseif($sys['type'] == 2){
				$typeId = $product['systematics_id'];
				$categoryId = $sys['superior_id'];
				DB::table('product')->where(['id' => $product['id']])->update(['category_id'=> $categoryId, 'type_id' => $typeId ,'systematics_id' => null]);
			}elseif($sys['type'] == 3){
				$ids = explode('-',$sys['superior_gene']);
				DB::table('product')->where(['id' => $product['id']])->update(['category_id'=> $ids[0], 'type_id' => $ids[1] , 'brand_id' => $product['systematics_id'] , 'systematics_id' => null]);
			}elseif($sys['type'] == 4){
				$ids = explode('-',$sys['superior_gene']);
				DB::table('product')->where(['id' => $product['id']])->update(['category_id'=> $ids[0], 'type_id' => $ids[1] , 'brand_id' => $ids[2] ]);
			}
			$productsArr []= $product;
		}
		return $productsArr;
	}

	public function getBrandWatch()
	{
		$brands = Db::table('systematics')->where(['superior_id' => 14])->field('title')->select();
		$b = [];
		foreach ($brands as $key => $brand) {
			$b [] = $brand['title'];
		}
		return $b;

	}

	public function getBrandBag()
	{
		$brands = Db::table('systematics')->where(['superior_id' => 5])->field('title')->select();
		$b = [];
		foreach ($brands as $key => $brand) {
			$b [] = $brand['title'];
		}
		return $b;

	}

	public function getBrandJewelry()
	{
		$brands = Db::table('systematics')->where(['superior_id' => 20])->field('title')->select();
		$b = [];
		foreach ($brands as $key => $brand) {
			$b [] = $brand['title'];
		}
		return $b;

	}

	public function addLevel1()
	{
		$contents = ['包袋','手表','首饰','配饰'];
		foreach ($contents as $content) {
			Db::table('systematics')->insert(['superior_id'=>0, 'superior_gene' => 0, 'type' => 1,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
		}

		echo 'ok';
	}

	public function addLevel2()
	{
		$this->addBag();
		$this->addWatch();
		$this->addJewelry();
		$this->addOther();
	}

	public function addLevel3()
	{
		$this->addWatchLevel3();
		$this->addBagLevel3();
		$this->addJewelryLevel3();
		$this->addOtherLevel3();
	}

	public function addLevel4()
	{
		$this->addWatchLevel41();
		$this->addWatchLevel42();
		$this->addWatchLevel43();
		$this->addWatchLevel44();
		$this->addWatchLevel45();
		$this->addWatchLevel46();
		$this->addWatchLevel47();
		$this->addWatchLevel48();
		$this->addWatchLevel49();
		$this->addBagLevel4();
		$this->addJewelryLevel4();
		$this->addOtherLevel4();
	}

	public function addBag()
	{
		$cate = Db::table('systematics')->where('title','包袋')->find();
		
		$contents = ['证件包','女士包袋','卡包','钥匙包','旅行箱','手机包','钱包','男士包袋','双肩背包'];
		foreach ($contents as $content) {
			Db::table('systematics')->insert(['superior_id'=>$cate['id'], 'superior_gene' => $cate['id'], 'type' => 2,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
		}

		echo 'ok';
	}

	public function addWatch()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		
		$contents = ['怀表','国产腕表','瑞士腕表','欧美腕表','日韩腕表','配件'];
		foreach ($contents as $content) {
			Db::table('systematics')->insert(['superior_id'=>$cate['id'], 'superior_gene' => $cate['id'], 'type' => 2,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
		}

		echo 'ok';
	}

	public function addJewelry()
	{
		$cate = Db::table('systematics')->where('title','首饰')->find();
		
		$contents = ['戒指/指环','耳线','脚链','手镯','耳环','耳夹','耳钉','手链','胸针','项坠/吊坠','摆件','项链','发饰','其他饰品'];
		foreach ($contents as $content) {
			Db::table('systematics')->insert(['superior_id'=>$cate['id'], 'superior_gene' => $cate['id'], 'type' => 2,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
		}

		echo 'ok';
	}

	public function addOther()
	{
		$cate = Db::table('systematics')->where('title','配饰')->find();
		
		$contents = ['腰带/皮带/腰链','帽子','围巾/丝巾/披肩','领带夹','太阳眼镜','宝珠/走珠/签字笔','钢笔','鞋履'];
		foreach ($contents as $content) {
			Db::table('systematics')->insert(['superior_id'=>$cate['id'], 'superior_gene' => $cate['id'], 'type' => 2,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
		}

		echo 'ok';
	}

	public function insertBagLevel3()
	{
		$cate = Db::table('systematics')->where('title','包袋')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					"Roger Vivier/RV/罗杰维维亚" => 'R',
				    "Coach/蔻驰"=> 'C',
				    "Stefano Ricci/史蒂芬劳.尼治"=> 'S',
				    "GIORGIO ARMANI/阿玛尼"=> 'G',
				    "CAPITAL JOY"=> 'C',
				    "ErmenegildoZegna/杰尼亚"=> 'E',
				    "Stuart Weitzman/SW"=> 'S',
				    "GiuseppeZanotti/朱塞佩·萨诺第"=> 'G',
				    "Berluti/伯尔鲁帝"=> 'B',
				    "Churchs"=> 'C',
				    "Chrome Hearts/克罗心"=> 'C',
				    "Montblanc/万宝龙"=> 'M',
				    "Harry Winston/海瑞温斯顿"=> 'H',
				    "I Do"=> 'I',
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $key => $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $key,'label'=>$content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
	public function insertWatchLevel3()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					"Roger Vivier/RV/罗杰维维亚" => 'R',
				    "Coach/蔻驰"=> 'C',
				    "Stefano Ricci/史蒂芬劳.尼治"=> 'S',
				    "GIORGIO ARMANI/阿玛尼"=> 'G',
				    "CAPITAL JOY"=> 'C',
				    "ErmenegildoZegna/杰尼亚"=> 'E',
				    "Stuart Weitzman/SW"=> 'S',
				    "GiuseppeZanotti/朱塞佩·萨诺第"=> 'G',
				    "Berluti/伯尔鲁帝"=> 'B',
				    "Churchs"=> 'C',
				    "Chrome Hearts/克罗心"=> 'C',
				    "Montblanc/万宝龙"=> 'M',
				    "Harry Winston/海瑞温斯顿"=> 'H',
				    "I Do"=> 'I',
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $key => $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $key,'label'=>$content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
	public function insertJewreyLevel3()
	{
		$cate = Db::table('systematics')->where('title','首饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					"Roger Vivier/RV/罗杰维维亚" => 'R',
				    "Coach/蔻驰"=> 'C',
				    "Stefano Ricci/史蒂芬劳.尼治"=> 'S',
				    "GIORGIO ARMANI/阿玛尼"=> 'G',
				    "CAPITAL JOY"=> 'C',
				    "ErmenegildoZegna/杰尼亚"=> 'E',
				    "Stuart Weitzman/SW"=> 'S',
				    "GiuseppeZanotti/朱塞佩·萨诺第"=> 'G',
				    "Berluti/伯尔鲁帝"=> 'B',
				    "Churchs"=> 'C',
				    "Chrome Hearts/克罗心"=> 'C',
				    "Montblanc/万宝龙"=> 'M',
				    "Harry Winston/海瑞温斯顿"=> 'H',
				    "I Do"=> 'I',
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $key => $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $key,'label'=>$content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
	public function insertOtherLevel3()
	{
		$cate = Db::table('systematics')->where('title','配饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					"Roger Vivier/RV/罗杰维维亚" => 'R',
				    "Coach/蔻驰"=> 'C',
				    "Stefano Ricci/史蒂芬劳.尼治"=> 'S',
				    "GIORGIO ARMANI/阿玛尼"=> 'G',
				    "CAPITAL JOY"=> 'C',
				    "ErmenegildoZegna/杰尼亚"=> 'E',
				    "Stuart Weitzman/SW"=> 'S',
				    "GiuseppeZanotti/朱塞佩·萨诺第"=> 'G',
				    "Berluti/伯尔鲁帝"=> 'B',
				    "Churchs"=> 'C',
				    "Chrome Hearts/克罗心"=> 'C',
				    "Montblanc/万宝龙"=> 'M',
				    "Harry Winston/海瑞温斯顿"=> 'H',
				    "I Do"=> 'I',
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $key => $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $key,'label'=>$content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}

	public function addBagLevel3()
	{
		$cate = Db::table('systematics')->where('title','包袋')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					"Phillip Lim/菲利林",
				    "Agnes b",
				    "Alaia",
				    "Alexander McQueen/亚历山大·麦昆",
				    "Alexander Wang/亚历山大·王",
				    "Anteprima",
				    "Balenciaga/巴黎世家",
				    "巴利/Bally8年",
				    "Balmain/巴尔曼",
				    "Bottege Veneta/BV/葆蝶家",
				    "Burberry/博柏利",
				    "BVLGARI/宝格丽",
				    "Cartier/卡地亚",
				    "Chanel/香奈儿",
				    "CHLOE/蔻依",
				    "Christian Dior/克里斯汀·迪奥",
				    "Comtesse",
				    "Celine/思琳",
				    "Dolce&Gabbana/杜嘉班纳",
				    "Delvaux/德尔沃",
				    "Designer",
				    "Dries Van Noten/德赖斯·范诺顿",
				    "Dunhill/登喜路",
				    "Tiffany & Co爱思卡达/ESCADA/蒂芙尼",
				    "ETRO/艾特罗",
				    "Fendi/芬迪",
				    "Van Cleef & Arpels/VCA/梵克雅宝",
				    "Furla/芙拉",
				    "Givenchy/纪梵希",
				    "Gucci/古驰",
				    "Hermès/爱马仕",
				    "HUGO BOSS/雨果博斯",
				    "Issey Miyake/三宅一生",
				    "Jean-Paul Gaultier/高缇耶",
				    "JIL SANDER/吉尔·桑达",
				    "Jimmy Choo/周仰杰",
				    "Kate Spade/凯特·丝蓓",
				    "KENZO/高田贤三",
				    "Lanvin/朗雯",
				    "LOEWE/罗意威",
				    "Longchamp/珑骧",
				    "Louis Vuitton/LV/路易·威登",
				    "Louis Quatorze/瑞克朵丝",
				    "Luella/卢埃拉",
				    "Mawi",
				    "MCM",
				    "Marc Jacobs/马克·雅可布",
				    "Marni",
				    "Miu Miu/缪缪",
				    "Moschino/莫斯奇诺",
				    "Mulberry/迈宝瑞",
				    "Philipp-Plein",
				    "Balmain/巴尔曼",
				    "Pierre Hardy",
				    "Polo Ralph Lauren/拉夫·劳伦",
				    "PRADA/普拉达",
				    "Proenza Schouler",
				    "Rag&Bone/瑞格布恩",
				    "Salvatore Ferragamo/SF/菲拉格慕",
				    "SergioRossi/塞乔·罗西",
				    "Stella McCartney/斯特拉-麦卡托尼",
				    "Tod's/托德斯",
				    "Tom Ford/汤姆·福特",
				    "Tory Burch/汤丽柏琦",
				    "TOUS/桃丝熊",
				    "Valentino/华伦天奴",
				    "Versace/范思哲",
				    "Victoria Beckham/维多利亚·贝克汉姆",
				    "Vivienne Westwood/维维安·韦斯特伍德",
				    "Yves Saint Laurent/YSL/圣罗兰"
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}

	public function addWatchLevel3()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
				    "PATEK PHILIPPE/百达翡丽",
				    "A. Lange & Sohne/朗格",
				    "Blancpain/宝珀",
				    "Vacheron Constantin/江诗丹顿",
				    "Breguet/宝玑",
				    "Jaeger-LeCoultre/积家",
				    "Audemars Piguet/爱彼",
				    "CARTIER/卡地亚",
				    "PIAGET/伯爵",
				    "RICHARD MILLE/里查德米尔",
				    "Glashütte Original/格拉苏蒂原创",
				    "Parmigiani Fleurier/帕玛强尼",
				    "Girard-Perregaux/GP芝柏表",
				    "Ulysse Nardin/雅典表",
				    "Franck Muller/法穆兰",
				    "Jaquet Droz/雅克德罗",
				    "Van Cleef & Arpels/VCA/梵克雅宝",
				    "Roger Dubuis/罗杰杜彼",
				    "Rolex/劳力士",
				    "OMEGA/欧米茄",
				    "IWC/万国表",
				    "BVLGARI/宝格丽",
				    "ZENITH/真力时",
				    "HUBLOT/宇舶",
				    "Panerai/沛纳海",
				    "CHRONOSWISS/瑞宝",
				    "Carl F. Bucherer/宝齐莱",
				    "Breitling/百年灵",
				    "Chopard/萧邦",
				    "Juvenia/尊皇",
				    "Corum/昆仑",
				    "Bell & Ross/柏莱士",
				    "MONTBLANC/万宝龙",
				    "Tudor/帝舵",
				    "Tag Heuer/泰格豪雅",
				    "Baume & Mercier/名士表",
				    "Longines/浪琴",
				    "Emile Chouriet/艾米龙",
				    "CODEX/豪度",
				    "BALL Watch/波尔",
				    "Ernest Borel/依波路",
				    "NOMOS",
				    "RADO/雷达",
				    "Oris/豪利时",
				    "Maurice Lacroix/艾美",
				    "Raymond Weil/蕾蒙威",
				    "WEMPE",
				    "NIVREL/尼芙尔",
				    "Frederique Constant/康斯登",
				    "Tissot/天梭",
				    "Mido/美度",
				    "Certina/雪铁纳",
				    "Movado/摩凡陀",
				    "北京表",
				    "Hamilton/汉米尔顿",
				    "SEIKO/精工",
				    "Citizen/西铁城",
				    "Casio/卡西欧",
				    "Seagull/海鸥",
				    "ORIENT/东方双狮",
				    "Balmain/巴尔曼",
				    "Titoni/梅花",
				    "浪陀",
				    "ZEPPELIN/齐博林",
				    "LACO/朗坤",
				    "ELYSEE/艾力舍",
				    "TIAN WANG/天王",
				    "ROSSINI/罗西尼",
				    "FIYTA/飞亚达",
				    "EBOHR/依波",
				    "Swatch/斯沃琪",
				    "Hermès/爱马仕",
				    "Louis Vuitton/LV/路易·威登",
				    "Dior/迪奥",
				    "CHANEL/香奈儿",
				    "Gucci/古驰",
				    "LAVARO/拉芙兰瑞",
				    "Tiffany/蒂芙尼",
				    "HUGO BOSS/雨果博斯"
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}

	public function addJewelryLevel3()
	{
		$cate = Db::table('systematics')->where('title','首饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
				    "Phillip Lim/菲利林",
				    "Agnes b",
				    "Alaia",
				    "Alexander McQueen/亚历山大·麦昆",
				    "Alexander Wang/亚历山大·王",
				    "anteprima",
				    "Balenciaga/巴黎世家",
				    "巴利/Bally8年",
				    "Balmain/巴尔曼",
				    "Bottege Veneta/BV/葆蝶家",
				    "Burberry/博柏利",
				    "BVLGARI/宝格丽",
				    "Cartier/卡地亚",
				    "Chanel/香奈儿",
				    "CHLOE/蔻依",
				    "Christian Dior/克里斯汀·迪奥",
				    "Comtesse",
				    "Celine/思琳",
				    "Dolce&Gabbana/杜嘉班纳",
				    "Delvaux/德尔沃",
				    "Designer",
				    "Dries Van Noten/德赖斯·范诺顿",
				    "Dunhill/登喜路",
				    "Tiffany & Co爱思卡达/ESCADA/蒂芙尼",
				    "ETRO/艾特罗",
				    "Fendi/芬迪",
				    "Van Cleef & Arpels/VCA/梵克雅宝",
				    "Furla/芙拉",
				    "Givenchy/纪梵希",
				    "Gucci/古驰",
				    "Hermès/爱马仕",
				    "HUGO BOSS/雨果博斯",
				    "Issey Miyake/三宅一生",
				    "Jean-Paul Gaultier/高缇耶",
				    "JIL SANDER/吉尔·桑达",
				    "Jimmy Choo/周仰杰",
				    "Kate Spade/凯特·丝蓓",
				    "KENZO/高田贤三",
				    "Lanvin/朗雯",
				    "LOEWE/罗意威",
				    "longchamp/珑骧",
				    "Louis Vuitton/LV/路易·威登",
				    "Louis Quatorze/瑞克朵丝",
				    "Luella/卢埃拉",
				    "Mawi",
				    "MCM",
				    "Marc Jacobs/马克·雅可布",
				    "Marni",
				    "Miu Miu/缪缪",
				    "Moschino/莫斯奇诺",
				    "Mulberry/迈宝瑞",
				    "Philipp-Plein",
				    "Balmain/巴尔曼",
				    "Pierre Hardy",
				    "Polo Ralph Lauren/拉夫·劳伦",
				    "PRADA/普拉达",
				    "Proenza Schouler",
				    "Rag&Bone/瑞格布恩",
				    "Salvatore Ferragamo/SF/菲拉格慕",
				    "SergioRossi/塞乔·罗西",
				    "Stella McCartney/斯特拉-麦卡托尼",
				    "Tod's/托德斯",
				    "Tom Ford/汤姆·福特",
				    "Tory Burch/汤丽柏琦",
				    "TOUS/桃丝熊",
				    "Valentino/华伦天奴",
				    "Versace/范思哲",
				    "Victoria Beckham/维多利亚·贝克汉姆",
				    "Vivienne Westwood/维维安·韦斯特伍德",
				    "Yves Saint Laurent/YSL/圣罗兰"
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}

	public function addOtherLevel3()
	{
		$cate = Db::table('systematics')->where('title','配饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
				    "Phillip Lim/菲利林",
				    "Agnes b",
				    "Alaia",
				    "Alexander McQueen/亚历山大·麦昆",
				    "Alexander Wang/亚历山大·王",
				    "anteprima",
				    "Balenciaga/巴黎世家",
				    "巴利/Bally8年",
				    "Balmain/巴尔曼",
				    "Bottege Veneta/BV/葆蝶家",
				    "Burberry/博柏利",
				    "BVLGARI/宝格丽",
				    "Cartier/卡地亚",
				    "Chanel/香奈儿",
				    "CHLOE/蔻依",
				    "Christian Dior/克里斯汀·迪奥",
				    "Comtesse",
				    "Celine/思琳",
				    "Dolce&Gabbana/杜嘉班纳",
				    "Delvaux/德尔沃",
				    "Designer",
				    "Dries Van Noten/德赖斯·范诺顿",
				    "Dunhill/登喜路",
				    "Tiffany & Co爱思卡达/ESCADA/蒂芙尼",
				    "ETRO/艾特罗",
				    "Fendi/芬迪",
				    "Van Cleef & Arpels/VCA/梵克雅宝",
				    "Furla/芙拉",
				    "Givenchy/纪梵希",
				    "Gucci/古驰",
				    "Hermès/爱马仕",
				    "HUGO BOSS/雨果博斯",
				    "Issey Miyake/三宅一生",
				    "Jean-Paul Gaultier/高缇耶",
				    "JIL SANDER/吉尔·桑达",
				    "Jimmy Choo/周仰杰",
				    "Kate Spade/凯特·丝蓓",
				    "KENZO/高田贤三",
				    "Lanvin/朗雯",
				    "LOEWE/罗意威",
				    "longchamp/珑骧",
				    "Louis Vuitton/LV/路易·威登",
				    "Louis Quatorze/瑞克朵丝",
				    "Luella/卢埃拉",
				    "Mawi",
				    "MCM",
				    "Marc Jacobs/马克·雅可布",
				    "Marni",
				    "Miu Miu/缪缪",
				    "Moschino/莫斯奇诺",
				    "Mulberry/迈宝瑞",
				    "Philipp-Plein",
				    "Balmain/巴尔曼",
				    "Pierre Hardy",
				    "Polo Ralph Lauren/拉夫·劳伦",
				    "PRADA/普拉达",
				    "Proenza Schouler",
				    "Rag&Bone/瑞格布恩",
				    "Salvatore Ferragamo/SF/菲拉格慕",
				    "SergioRossi/塞乔·罗西",
				    "Stella McCartney/斯特拉-麦卡托尼",
				    "Tod's/托德斯",
				    "Tom Ford/汤姆·福特",
				    "Tory Burch/汤丽柏琦",
				    "TOUS/桃丝熊",
				    "Valentino/华伦天奴",
				    "Versace/范思哲",
				    "Victoria Beckham/维多利亚·贝克汉姆",
				    "Vivienne Westwood/维维安·韦斯特伍德",
				    "Yves Saint Laurent/YSL/圣罗兰"
				];		
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
//增加一个品牌--包袋
	public function addBagL3(Request $request)
	{
		$data = $request->post();
		$cate = Db::table('systematics')->where('title','包袋')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					
				    $data['brand']
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
//增加一个品牌--手表
	public function addWatchL3(Request $request)
	{
		$data = $request->post();
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
				    $data['brand']
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
//增加一个品牌--首饰
	public function addJewelryL3(Request $request)
	{
		$data = $request->post();
		$cate = Db::table('systematics')->where('title','首饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
				    $data['brand']
				];
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}
//增加一个品牌--包袋
	public function addOtherL3(Request $request)
	{
		$data = $request->post();
		$cate = Db::table('systematics')->where('title','配饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();
		
		$contents = [
					$data['brand']
				];		
		foreach ($cate2 as $c2) {
			foreach ($contents as $content) {
				Db::table('systematics')->insert(['superior_id'=>$c2['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'], 'type' => 3,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		echo 'ok';
	}

	

	public function addBagLevel4()
	{
		$cate = Db::table('systematics')->where('title','包袋')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();

		$contents = ['Birkin铂金包','Kelly凯莉包','Lindy林迪包','Garden Park空中花园','Evelyne伊芙琳','Jypsiere吉普赛包','Bolide保龄球包','Picotin Lock锁头包','Herbag','Toolbox','Passe Guide','Roulis','Double Sens','Victoria维多利亚包','Cabag'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '爱马仕/Hermès'])->select();

		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
					Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
				}
			}
		}



		$contents = ['LEBOY','CF','2.55','woc','JUMBO','coco handel','GST','PST','vintage'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '香奈儿/Chanel'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}



		$contents = ['neverfull','keepall','Alma','Speedy','Neonoe','Judy','Capucines','Twist','Petite Malle','Chain','Fragment藤原浩','noe','Cluny BB','Montaigne蒙田','Palermo派拉蒙','Kleber','pallas','kasai','one handle','Brea','Lockme'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '路易威登/Louis Vuitton/LV'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['Lady Dior戴妃包','DIORSOFT','MISS DIOR','DIOR NEW LOCK','DIORISSIMO','DIOR GRANVILLE','GST','DIOR PANAREA'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '克里斯汀·迪奥/Christian Dior'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['LUGGAGE','CLASSIC','TWISTED CABAS','CABAS PHANTOM','TRAPEZE','TRIO','BELT','SEAU SANGLE','FRAME','TRI','FOLD','TROTTEUR','CLASP','SOFT CUBE','BIG BAG'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '思琳/celine'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['CAHIER','PIONNIERE','DOUBLE','RIBBON','杀手包'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '普拉达/PRAD'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['PIAZZA手袋','PIAZZA手袋','THE LAUREN 1980','KNOT手拿包','CABAT手袋','ROMA','HOBO'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '葆蝶家/Bottege Veneta/BV'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['Peekaboo','By The Way','Dotcom','2JOURS','3JOURS','3BAGUETTE','Kan I'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '芬迪/Fendi'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['City','Mini City','Town','Papier','机车包'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '巴黎世家/Balenciaga'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['狗头系列','小鹿系列','Antigona','Pandora','Hobo'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '纪梵希/Givenchy'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['FLAMENCO','PASEO','AMAZONA','ALAMO','LEO'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '罗意威/LOEWE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['Sylvie','SOHO','Marmont','Dionysus酒神包','padlock','波士顿包','竹节包','PADLOCK','Marmont'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '古驰/Gucci'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
			}
		}


		$contents = ['小猪包','Nile','Faye','Hudson','Indy','Marcie','Lexa','Georgia','Hayley','Paraty','Kurtis'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '蔻依/CHLOE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
				foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

	}

	public function addWatchLevel41()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();

		$contents = ['特别限量','猎人怀表','怀表 Lepine','万年历','超级复杂功能计时','复杂功能计时','运动系列 NAUTILUS','TWENTY~4','GONDOLO','AQUANAUT','GOLDEN ELLIPSE','古典表 CALATRAVA'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '百达翡丽/PATEK PHILIPPE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['LANGE 1','ZEITWERK','萨克森 SAXONY','1815','理查德朗格 RICHARD LANGE','卡巴莱 CABARET','LANGEMATIK','EDITION"HOMAGE TO F.A.LANGE"','双追针计时 DOUBLE SLIT','TOURBOGRAPH "POUR LE MÉRITE"','猫头鹰 LANGE ZEITWERK','DATOGRAPH'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '朗格/A. Lange & Sohne'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['五十噚系列 FIFTY FATHOMS','女装系列 WOMEN','特别系列 SPECIALTIES','经典系列 VILLERET','开创系列 L-EVOLUTION','领袖系列 LÉMAN','巨匠系列 LE BRASSUS'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝珀/Blancpain'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['传承系列 PATRIMONY','传袭系列 TRADITIONNELLE','和韵系列 HARMONY','马耳他系列 MALTE','纵横四海系列 OVERSEAS','1972系列','奎德利系列 QUAI DE L’ILE','历史名作系列 HISTORIQUES','创意时光系列 HEURES CRÉATIVES','艺术大师系列 METIERS D\'ART','伍陆之型 FIFTYSIX','阁楼工匠系列 LES CABINOTIERS'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '江诗丹顿/Vacheron Constantin'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['经典 CLASSIQUE','高级珠宝腕表','那不勒斯皇后 REINE DE NAPLES','TYPE XX - XXI - XXII 系列','传承 HERITAGE','航海 MARINE','经典复杂 GRANDES COMPLICIATIONS','传世 TRADITION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝玑/Breguet'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['北宸系列','超凡复杂工艺系列HYBRIS ARTISTICA','极限运动大师系列MASTER EXTREME','地球物理天文台GEOPHYSIC','约会RENDEZ-VOUS','大师系列MASTER','双翼系列DUOMèTRE','翻转腕表系列REVERSO','超薄大师MASTER ULTRA THIN','超卓复杂腕表系列HYBRIS MECHANICA','MASTER COMPRESSOR','高级珠宝腕表EXTRAORDINARY','阿斯顿马丁AMVOX','超卓传统大师MASTER GRANDE TRADITION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '积家/Jaeger-LeCoultre'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['高级珠宝HAUTE JOAILLERIE系列','皇家橡树概念系列','JULES AUDEMARS','皇家橡树离岸型ROYAL OAK OFFSHORE ',' 皇家橡树ROYAL OAK ','千禧','经典','传统TRADITION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '爱彼/Audemars Piguet'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['CALIBRE DE CARTIER','高级制表CARTIER FINE EATCHMAKING','坦克TANK',' 桑托斯SANTOS DE CARITER',' 帕莎PASHA DE CARTIER',' ROTONDE DE CARTIER ','龟形TORTUE',' 浴缸BAIGNOIRE',' CARTIER LIBRE ','PANTHèRE DE CARTIER',' RONDE DE CARTIER',' HYPNOSE',' DRIVE DE CARTIER 系列',' 钥匙CLé DE CARTIER',' CRASH ','创意宝石腕表 ','BALLON BLANC DE CARTIER','蓝气球BALLON BLEU DE CARTIER','DELICES DE CARTIER','酒桶型TONNEAU','高级珠宝腕表HIGH JEWELRY WATCHES','CAPTIVE DE CARTIER','SANTOS','芭蕾BALLERINE','2011 NEW MODELS','黄金鳄鱼LA DONA DE CARTIER','21世纪系列21 CHRONOSCAPH','CARTIER','LE CIRQUE ANIMALIER DE',' 豹PANTHERE SECRETE DE CARTIER',' 跑车系列ROADSTER DE CARTIER'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '卡地亚/CARTIER'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['POSSESSION',' 非凡珍品',' 珠宝腕表',' PIAGET POLO',' LIMELIGHT',' ALTIPLANO',' BLACK -TIE',' SUNLIGHT JOURNEY',' SUNNY SIDE OF LIFE',' 创意 ','龙与凤',' 逆流UPSTREAM'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '伯爵/PIAGET'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['女士系列','男士系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '里查德米尔/RICHARD MILLE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['偏心PANO ','女表LADY',' 复古系列VINTAGE',' 议员系列SENATOR ','精髓QUINTESSENTIALS',' 艺术与工艺ART&TECHNIK',' 1878 MORITZ GROSSMANN','GLASHüTTE ORIGINAL',' PANO XL 42MM COLLECTION',' PANO CLASSIC STAR COLLECTION',' SPORT EVOLUTION',' SENATOR NAVIGATOR'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '格拉苏蒂原创/Glashütte Original'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel42()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['BUGATTI',' TORIC',' PERSHING',' TONDA',' KALPA',' OVALE',' TRANSFORMA ','PERSHING CBF HOMMES','PERSHING CBF FEMMES ','QUANTIEME PERPETUEL RETROGRADE','CHRONOGRAPH',' KALPARISMA',' KALPA DONNA','KALPA PICCOLA',' LIMITED EDITIONS',' GRAND COMPLICATION ','BUGATTI TYPE370 ',
'TOURBILLON','RETROGRADE PERPETUAL CALENDAR',' GMT',' CHRONOGRAPH FLY-BACK','KALPA GRAPH',' KALPA GRANDE',' JEWELLERY'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '帕玛强尼/Parmigiani Fleurier'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['COMPETIZIONE',' VINTAGE 1945',' HERITAGE',' CAT\'S EYE',' 1966',' LAUREATO',' BRIDGES',' 特别',' 女表',' 男表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> 'GP芝柏表/Girard-Perregaux'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['经典CLASSIC',' 玉玲珑JADE',' 奇想FREAK',' 经理人EXECUTIVE',' 潜水DIVER ','航海MARINE',' 复杂功能',' 鎏金CLASSICO','女装腕表LADIES WATCHES',
'克里姆林宫限量纪念套表KREMLIN SET',' 圣马可SAN MARCO',' 米开朗基罗MICHELANGELO','双时区DUAL TIME',' MACHO钯金950腕表MACH PALLADIUM 950',
'160周年纪念ANNIVERSARY 160',' 珍贵独特表款',' 限量版腕表','万年历PERPETUAL CALENDARS'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '雅典表/Ulysse Nardin'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['LADIES\'COLLECTION',' MEN\'S COLLECTION',' GRAND COMPLICATIONS',' NEW SARATOGE',' CRAZY HOURS',' YACHTING','VANGUARD',' THE CONQUISTADOR LINE ',
'VINTAGE',' INFINITY RONDE',' DUBAIL',' RONDE',' INFINITY',' GALET ','HEART','GRACE CURVEX',' DOUBLE MYSTERY','COLOR DREAMS',' VEGAS',' SECRET HOURS',
' MASTER SQUARE',' MARINER','LONG ISLAND',' LIBERTY/FREEDOM',' EVOLUTION/REVOLUTION',' DOUBLE MYSTERY 00',' CONQUISTADOR CORTEZ',
'CONQUISTADOR GPG',' CONQUISTADOR',' CINTRéE CURVEX',' CASABLANCA',' ART DECO',' AETERNITAS/MEGA',' BLACK CROCO',' SQUELETTE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '法穆兰/Franck Muller'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['自动玩偶系列AUTOMATA','SW','优雅 8系列LADY 8 COLLECTION',' 时分小针盘系列PETITE HEURE MINUTE',
'大秒针系列GRANDE SECONDE',' 星辰系列ASTRALE ','艺术工坊系列ATELIERS D\'ART',' 大秒针运动系列GRANDE SECONDE SW COLLECTION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '雅克德罗/Jaquet Droz'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['高级珠宝腕表',' CADENAS',' ALHAMBRA',' CHARMS',' 皮埃尔·雅宝系列PIERRE ARPELS',' 诗意复杂功能腕表',' 非凡表盘腕表',' 男士腕表',' 女士腕表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '梵克雅宝/Van Cleef & Arpels'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['HOMMAGE（致敬系列）',' VELVET（名伶系列）',' PULSION（冒险家系列）',' LA MONéGASQUE（玩家系列）',' EXCALIBUR（王者系列）',' 历史'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '罗杰杜彼/Roger Dubuis'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['珍珠淑女型',' 空中霸王型',' SKY-DWELLER ','女装日志型',' 海使型',' 蚝式恒动',' 游艇名仕型',' 潜航者型',' MILGAUSS',' 格林尼治型II',
'探险家型',' 宇宙计型迪通拿 ','星期日历型',' 日志型 ','切利尼'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '劳力士/Rolex'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['星座CONSTELLATION',' 海马SEAMASTER',' 超霸SPEEDMASTER',' 碟飞DE VILLE',' 特别SPECIALITIES'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '欧米茄/OMEGA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['JUBILEE',' 飞行员PILOT\'S WATCHES',' 工程师INGENIEUR FAMILY',' 海洋时计AQUATIMER FAMILY',' 柏涛菲诺PORTOFINO FAMILY',
'达文西DA VINCI FAMILY',' 葡萄牙PORTUGIESER',' GST CHRONOGRAPH RTTRAPANTE',' 复刻版VINTAGE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '万国表/IWC'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['HAUTE HORLOGERIE',' DIVAS’ DREAM',' OCTO ','高级珠宝腕表',' LVCEA ','SERPENTI',' B.ZERO1',' BVLGARI?BVLGARI',
'DIAGONO',' DANIEL ROTH ','BB LADY',' MEDITERRANEAN EDEN',' ASTRALE',' Gerald Genta Octo',' Sotirio Bulgari',' SOLO TEMPO',
'QUADRATO',' OVALE',' ASSIOMA D',' RETTANGOLO',' DIAGONO PROFESSIONAL',' ERGON',' ASSIOMA'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝格丽/BVLGARI'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel43()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['SWIZZ BEATZ胶囊',' CHRONOMASTER',' DEFY',' 飞行员PILOT',' ELITE',' STAR',' CLASS',' ACADEMY EL PRIMERO'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '真力时/ZENITH'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['MP系列',' SPIRIT OF BIG BANG',' 经典融合CLASSIC FUSION',' BIG BANG',' MASTERPIECE',' STEEL WHITE',' ZIRCONIUM',' 王者至尊KING POWER'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宇舶/HUBLOT'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['RADIOMIR',' RADIOMIR 1940',' LUMINOR 1950',' LUMINOR',' LUMINOR DUE',' 限量珍藏款'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '沛纳海/Panerai'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['时尊系列',' 天狼星SIRIUS'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '瑞宝/CHRONOSWISS'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['白蒂诗PATHOS',' 爱德玛尔ADAMAVI',' 雅丽嘉ALACRIA',' 马利龙MANERO',' 柏拉维PATRAVI'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝齐莱/Carl F. Bucherer'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['航空飞行计时腕表',' 宾利BREITLING FOR BENTLEY',' 挑战者',' 蒙柏朗计时MONTBRILLANT',' 超级海洋文化SUPEROCEAN HéRITAGE',
'银河GALACTIC',' 越洋TRANSOCEAN',' 复仇者AVENGER',' 超级海洋SUPEROCEAN ','机械计时CHRONOMAT',' 专业PROFESSIONAL',
'航空计时NAVITIMER',' 太空计时腕表CHRONOSPACE',' 自动计时CHRONO-MATIC'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '百年灵/Breitling'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['L’HEURE DU DIAMANT',' 钻石手表',' LA STRADA',' HAPPY DIAMONDS',' CLASSIC系列',' IMPERIALE',' 经典赛车CLASSIC RACING系列',
'L.U.C',' Precious Chopard',' ANIMAL WORLD',' HIGH JEWELLERY',' 艾尔顿·约翰腕ELTON JOHN',' 女士'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '萧邦/Chopard'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['经典',' 世界时间',' 两地时间 ','收藏家COLLECTOR\'S ITEMS','星球 PLANET','典雅C CLASSIQUEC','典雅9 CLASSIQUE9','星钻BIARRITZ'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '尊皇/Juvenia'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['泡泡系列',' 经典系列 ','金桥系列',' 海军上将系列',' BUBBLE',' HERITAGE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '昆仑/Corum'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['EXPERIMENTAL',' INSTRUMENTS',' VINTAGE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '柏莱士/Bell & Ross'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel44()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['明星 LEGACY','SUMMIT 峰睿系列','1858系列','传统','传承精密计时','宝曦','明星经典','HERITAGE SPIRIT系列','维莱尔COLLECTION VILLERET','尼古拉斯凯世NICOLAS RIEUSSEC','明星STAR','4810','时光行者TIMEWALKER','摩纳哥公主','TIMEWRITER','旅行时计','百年限量SUMMIT','侧影PROFILE','运动SPORT'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '万宝龙/MONTBLANC'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['公主系列','王子系列','满冠系列','迅骑计时腕表','迅骑黑盾型','极帜型','领潜型','碧湾BLACK BAY','1926系列','风尚','启承','玫瑰','经典','骏珏','王子型及公主型','FASTRIDER CHRONO','NORTH FLAG','FASTRIDER BLACK SHIELD','HERITAGE RANGER','STYLE','PELAGOS','AERONAUT','王子运动','FASTRIDER','HERITAGE CHRONO','海洋王子型','GRANTOUR','CLAIR DE ROSE','HERITAGE ADVISOR'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '帝舵/Tudor'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['智能腕表TAG HEUER CONNECTED MODULAR 45','卡莱拉TAG HEUER CARRERA','摩纳哥TAG HEUER MONACO','林肯TAG HEUER LINK','竞潜TAG HEUER AQUARACER','F1 TAG HEUER FORMULA 1','专业运动TAG HEUER','蒙扎MONZA','概念表','超级卡莱拉TAG HEUER GRAND CARRERA','高尔夫','梅赛德斯-奔驰SLR','银石赛道SILVERSTONE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '泰格豪雅/Tag Heuer'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['约定PROMESSE','克里顿CLIFTON','汉伯顿HAMPTON','克莱斯麦CLASSIMA','卡普蓝CAPELAND','灵霓LINEA','利维拉','WILLIAM BAUME'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '名士表/Baume & Mercier'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['马术','制表传统','优雅','运动','经典复刻','巴黎饰钉','琴韵','贝雅','LES RAVISSANTES','LES ELéGANTES','雅致','军旗'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '浪琴/Longines'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['冰峰','太阳神系列','缘系列','挑战者','智慧','明珠','净雅','奥德赛','银河','莱蒙','时光之翼','当代奢华','传承','EC2000 ','子爵 '];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '艾米龙/Emile Chouriet'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['卡佩尔系列CHAPEL','极臻系列INFINITY','永恒系列INTEMPORELLE','经典系列CLASSIC','身份系列IDENDITY'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '豪度/CODEX'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['战火勇士FIREMAN','指挥官CONDUCTOR','铁路长官TRAIN MASTER','工程师碳氢ENGINEER HYDROCARBON','工程师长官升级ENGINEER MASTER II','工程师升级ENGINEER II'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '波尔/BALL Watch'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['传奇天文台','真爱系列','迪奴','洛奇系列','维纳斯系列','巴奴系列','运动家系列','豪爽系列','音韵HARMONIC COLLECTION','星宇COSMIC SERIES','乔斯JOSS SERIES',' 典雅DANAUS SERIES','雅仕GARY SERIES','雅丽YALLY SERIES','传奇','波莱尔BORELCHRONO COLLECTION','公爵DUKE COLLECTION','布拉克BRAQUE COLLECTION','复古RETRO COLLECTION','蝴蝶花IRIS COLLECTION','鸡尾酒COCKTAIL COLLECTION','祖尔斯JULES BOREL COLLECTION','皇室ROYAL COLLECTION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '依波路/Ernest Borel'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['PETIT FOUR','AQUA','LUX','MINIMATIK','METRO','LAMBDA','AHOI','ZURICH','CLUB','TANGOMAT','TETRA',' ORION','LUDWIG','TANGENTE','DOCTORS WITHOUT BORDERS '];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> 'NOMOS'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['皓星HYPERCHROME','钻霸DIAMASTER','帝星及创始型D-ORIGINAL','依莎ESENZA','晶萃CENTRIX','真系列TRUE','RX','银钻SINTRA','精密陶瓷INTEGRAL','整体陶瓷CERAMICA','晶璨系列','真薄系列','佛罗伦萨系列','珍珠陶瓷COUPOLE','金表JOAILLERIE','拱形ANATOM'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '雷达/RADO'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel45()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['CAPE','COD','文化','航空','潜水','运动','DIVINA'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '豪利时/Oris'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['AIKON','FIABA','ELIROS','奔涛PONTOS','匠心MASTERPIECE','典雅LES','CLASSIQUES','STARSIDE','MIROS','DIVINA '];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '艾美/Maurice Lacroix'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['男装腕表',' 女装腕表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '蕾蒙威/Raymond Weil'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['WEMPE ZEITMEISTER',' WEMPE CHRONOMETERWERKE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> 'WEMPE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['PIECE UNIQUE',' 潜水系列',' 创新系列',' 继承系列',' EDITION DESIGN'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '尼芙尔/NIVREL'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['超薄',' 传统型智能腕表',' 百年典雅CLASSICS ','自动女装LADIES AUTOMATIC',' 赛艇Runabout',' 古董赛车',' 自家机芯MANUFACTURE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '康斯登/Frederique Constant'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['怀旧系列','时尚T-GOLD','经典T-CLASSIC','运动T-SPORT','触屏系列TOUCH COLLECTION','梦媛','卓越','T-LADY','SPECIAL COLLECTIONS','T-POCKET','T-TREND'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '天梭/Tissot'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['灵感源于建筑','领航者','都瑞DORADA','指挥官COMMANDER','布鲁纳BELLUNA','完美ALL DIAL','舵手MULTIFORT','贝伦赛丽BARONCELLI','BIG BEN','海星OCEAN STAR','长城GREAT WALL'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '美度/Mido'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['都市元素','运动元素','潜水元素','传承元素','女士自动LADY AUTOMATIC COLLECTION','女士石英LADY QUARTZ COLLECTION','男式自动GENT AUTOMATIC COLLECTION','男式石英GENT QUARTZ COLLECTION','BIG BEN','海星OCEAN STAR','长城GREAT WALL'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '雪铁纳/Certina'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['爱梦莎AMOROSA','现代经典MODERN CLASSIC','瑞纤ULTRA SLIM','瑞动','瑞界','月熊RONDIRO','男式自动GENT AUTOMATIC COLLECTION','瑞红RED LABEL','博物馆MUSEUM','波特BOLD','贝拉BELA','爱莎ESPERANZA','TC超薄MOVADO TC','摩凡陀经典圆点 MOVADO DOT','美里','思锐SERIO','运动终极版SE® EXTREME','运动版SE','蓝宝石SAPPHIRE','酷爵MOVADO QUADRO','思博特MOVADO SPORTIVO','摩凡陀思卡MOVADO CIRCA','当代MODERNA','月龙 运动版LUNO SPORT','露玛LUMA','丽诺LINIO','和谐HARMONY','都睿DURA','德隽DATRON','协奏曲CONCERTO','思可CIRCLO','赛蕾娜CERENA','贝丽拉BRILA','贝拉时尚BELAMODA'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '摩凡陀/Movado'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel46()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['东方文化系列','复刻系列','经典系列','灵感系列','名筑系列','北海系列','猎户系列','丝语系列','潜锋系列','高端定制','机械','珐琅','中华陀飞轮','雅典娜深浮雕金表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '北京表'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['百老汇','卡其海军KHAKI NAVY','探险VENTURA','卡其野战KHAKI FIELD','美国经典COLLECTION','卡其航空KHAKI AVIATION','爵士JAZZMASTER','卡其KHAKI'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '汉米尔顿/Hamilton'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['SPRING DRIVE','ANANTA','ASTRON','SPORTURA','PREMIER','PRESAGE','SPIRIT','LUKIA','VIVACE','PROSPEX','GRAND SEIKO','AGLARE LUXURIES','MECHANICAL','SOLAR','KINETIC','CHRONOGRAPH','QUARTZ PAIR','SEIKO 5','QUARTZ ASTRON','JAPAN DOMESTIC','Velatura'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '精工/SEIKO'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['XC','PROMASTER','CITIZEN L','光动能卫星对时表','Eco-Drive One','三问报时','万年历','STILETTO','WICCA','CAMPANOLA','Ti+IP','真钻','胧月','ARCLY','正装','运动','时尚','石英','光动能表','机械','商务休闲'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '西铁城/Citizen'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['G-SHOCK','EDIFICE','OCEANUS','PROTREK','大众指针ANALOGUE','BABY-G','SHEEN','LINEAGE','运动CASIOSPORT','REGULAR','机械','珐琅','中华陀飞轮','雅典娜深浮雕金表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '卡西欧/Casio'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['纪念系列','设计师系列','沃朶系列','纤薄系列','基础系列','女士/情侣系列','多功能系列','典藏系列','码表系列','陀飞轮系列','商务运动表','陀飞轮金表','时尚情侣表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '海鸥/Seagull'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['运动','时尚','中性及对表','女表系列','潜水系列','经典表款','东方之星','DRESSY ELEGANT','CLASSIC DESIGN','专业潜水员DIVING SPORTS AUTOMATIC','光能动力','SP','DISK','时装','传统'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '东方双狮/ORIENT'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['ELEGANCE CHIC XS','BALMAIN DE BALMAIN II MINI','FLAMEA II','CLASSIC LADY AUTO','B-CRAZY CHAIN','BALMAIN DE BALMAIN','LAELIA LADY II','ORITHIA II','BALMYA ROUND','TILIA II','ELEGANCE CHIC MINI XS','HAUTE ELEGANCE OVAL','MAESTRIA LADY ROUND II','BALMAIN DE BALMAIN II XS','LITTLE EXCESSIVE','CLASSICA LADY AUTO','KERRIA','CLASSIC GRANDE LADY','MADRIGAL CERAMIC','MADRIGAL LADY','HAUTE ELEGANCE','MADRIGAL LADY OVAL','LA VELA II','MADRIGAL GMT 24H','BALMAN CHRONO SPORT','BELEGANZA','CLASSIC R GENT AUTO','CLASSIC R GRANDE','BALMAIN CLASSICA AUTO','ELEGANCE CHIC MINI','卵石系列','爱恋系列','名媛系列','拱廊系列','歌剧系列','芭莎系列','妲菲系列','蔓藤珠宝系列','至美系列','经典系列','宝曼尼亚系列','宝曼尼亚多功能运动系列','宝曼尼亚运动系列','宝曼尼亚陶瓷系列','艺术家系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝曼/Balmain'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

	}

	public function addWatchLevel47()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['女士','男士'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '梅花/Titoni'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['臻品系列','水晶之恋系列','星空系列','摩尔福蝶系列','简雅系列','璀璨系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '浪陀'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['LZ127格拉夫齐博林系列','LZ127伯爵齐博林系列','LZ127计时码系列','百年齐博林系列','北极星系列','空中公主系列','超薄计时系列','超薄系列','维多利亚号女士系列','夜航系列','LZ127大西洋系列','LZ129兴登堡系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '齐博林/ZEPPELIN'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['LADIES WATCHES','运动系列','古典1960S系列','计时码表系列','蓝绝系列','飞行员系列','怀旧牛仔系列','海洋系列','经典系列','特种部队系列','海军系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '朗坤/LACO'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['约翰·马斯系列 JOCHEN COURT','竞赛COMPETITION','格拉芙·冯·特里普斯GRAF BERGHE VON TRIPS','女士LADIES','总裁EXECUTIVE','经典CLASSIC'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '艾力舍/ELYSEE'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['MI·X','歆动系列','典韵系列','领航系列','锋尚','电商系列','俪姿','锋睿','名匠','恒隽','博雅','雅仕','龙凤','风云','轮时代','传奇','尚·Shine','金骑士','天爵陀飞轮','灵动','团购礼品'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '天王/TIAN WANG'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['光电能电波','锐冠运动','雅尊商务','典美时尚','陀飞轮'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '罗西尼/ROSSINI'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addWatchLevel48()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['SOLO','特供','Young+','花语系列','印系列','IF','飞行','艺系列','大师','极限','锋逸','金淳','卓雅','凯旋','倾城','心弦','摄影师','恒昱','祈福','芯动','经典','琅轩','玲珑','四叶草','航天'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '飞亚达/FIYTA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['至尊系列','飞驰系列','蝶恋花系列','探索者系列','炫彩系列','凌锐系列','卓越系列','非凡系列','夏洛克系列','精英系列','主旋律系列','宇飞系列','卡纳','动感时代','臻典系列','珍藏版','大师传奇TIMELESS VALUES','珍宝系列','时代元素','天翼系列','雅典娜ATHENA','都市经典','光环GLORY','刚毅DETERMINATION'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '依波/EBOHR'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['ORIGINALS','SWATCH TOUCH','TIME TO SWATCH',' MEN\'S WATCHES','IRONY','WOMEN\'S WATCHES','SKIN','特别款','基本款系列','新品系列','欲罢不能','2015春夏系列','D\'SCHWIZER','LOVE','DENIM','SUMMER BUZZ','ETHNIC','CLASSIC','CLUB WATCH','KALINKA-MALINKA','SWATCH EST. 1983','ROLAND GARROS','GOTO DESIGN','JOSé CARLOS CASADO','THE SWATCH ART PEACE HOTEL','IRONY CHRONO','SCUBA LIBRE'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '斯沃琪/Swatch'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['NANTUCKET','MéDOR','HEURE H','FAUBOURG','SLIM D\'HERMèS','KELLY','CAPE COD','ARCEAU','FAUBOURG MANCHETTE','H AU GALOP','ARCEAU LIPSTICK','ARCEAU PETITE LUNE','CLIPPER SPORT','DRESSAGE','H-WATCH','TANDEM','PASSE PASSE','GRIZZARD','CROISIERE','CHERCHE','BARENIA','KELLY 2','H HOUR','CLIPPER'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '爱马仕/Hermès'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['TAMBOUR REGATTE NAVY','TAMBOUR BRUN','TAMBOUR ALL BLACK','高级珠宝系列','智能腕表','TAMBOUR MOON','VOYAGER','ESCALE','TAMBOUR EVOLUTION','TAMBOUR SLIM','精湛工艺系列','TAMBOUR SPIN TIME','TAMBOUR','TAMBOUR TWIN CHRONO','TAMBOUR VOYAGE','TAMBOUR DISC','LV Fifty Five','SPEEDY','TAMBOUR IN BLACK','EMPRISE','潜水TAMBOUR NAUTICAL','TAMBOUR GLAMOUR'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '路易·威登/Louis Vuitton/LV'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['卓越腕表','DIOR GRAND BAL','LA D DE DIOR','DIOR VIII','CHIFFRE ROUGE','La Mini D de Dior Rose des vents','DIOR CHRISTAL'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '迪奥/Dior'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['J12','BOY · FRIEND','PREMIERE','CODE COCO','MONSIEUR DE CHANEL','MADEMOISELLE PRIVé','珠宝腕表'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '香奈儿/CHANEL'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

	}

	public function addWatchLevel49()
	{
		$cate = Db::table('systematics')->where('title','手表')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();


		$contents = ['CONSTANCE','HORSEBIT','guccissima','interlocking','DIAMANTISSIMA','LE MARCHé DES MERVEILLES','GG2570','G-TIMELESS','G-FRAME','有机玻璃Vintage Web','U-PLAY','U-PLAY','女士','G-METRO','GUCCI COUPé','PANTHEON','G-CLASS','GUCCI','CHIODO','TWIRL','G CHRONO','I-GUCCI','TORNABUONI','G-GUCCI','MARINA CHAIN','1921'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '古驰/Gucci'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['钢珠表硬币系列','时光触摸系列','艾斯黛拉系列','奥利维亚系列','钛金系列','欧菲亚系列','彩色钢珠一代','伽勒斯系列','矩形系列','复古银系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '拉芙兰瑞/LAVARO'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['Tiffany HardWear','Tiffany T','Tiffany Keys','Return to Tiffany 系列','Tiffany 1837 系列','Tiffany Infinity','Tiffany Victoria','Atlas系列','Tiffany Soleste','蒂芙尼黄钻','Tiffany Metro','Tiffany Bow','ATLAS系列','Tiffany East West','Tiffany Cocktail Watch系列','TIFFANY CT60系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '蒂芙尼/Tiffany'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		$contents = ['ALLUSION','COPENHAGEN','HORIZON','THE PROFESSIONAL','SIGNATURE','OSLO','PARIS','PILOT VINTAGE','ECLIPSE','MODERN','RACING','JILLIAN','COMPANION','GENTLEMAN','SUCCESS','NEO','ORIGIN','ARCHITECTURE','SLIM ULTRA ROUND','AEROLINER','AVIATOR','ESSENCE','NAVIGATOR','COMMANDER','GOVERNOR','THE JAMES','TRADITION','GRAND PRIX','RAFALE','JET','JACKSON','HERITAGE','BILBAO','HONG KONG'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '雨果博斯/HUGO BOSS/BOSS'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}

		echo 'ok';
	}

	public function addJewelryLevel4()
	{
		$cate = Db::table('systematics')->where('title','首饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();

		$contents = ['JUSTE UN CLOU系列','AMULETTE DE CARTIER系列','LOVE系列','PANTHèRE DE CARTIER系列','TRINITY系列','CACTUS DE CARTIER 系列','钻石系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '卡地亚/Cartier'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['仲夏夜之梦','双年展戒指','Hyd&ocircr','Tellus','Aeros','Héphaistos','东方花园系列','浪漫英式花园系列','浩瀚星空系列','芭蕾系列','中国红限量系列','Effeuillage系列','情人节系列','四叶草Alhambra系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '梵克雅宝/Van Cleef & Arpels/VCA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['SERPENTI系列','BVLGARI BVLGARI系列','DIVA系列','B.ZERO1系列','MVSA系列','MONETE系列','PARENTESI系列','SAVE THE CHILDREN系列','SAPPHIRE FLOWER系列','INTARSIO系列','ALLEGRA系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝格丽/BVLGARI'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['Tiffany HardWear','Tiffany T','Tiffany Keys','Return to Tiffany 系列','Tiffany 1837 系列','Tiffany Infinity','Tiffany Victoria','Atlas系列','Tiffany Soleste','蒂芙尼黄钻','Tiffany Metro','Tiffany Bow','ATLAS系列','Tiffany East West','Tiffany Cocktail Watch系列','TIFFANY CT60系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '蒂芙尼/Tiffany & Co爱思卡达/ESCADA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}

	public function addOtherLevel4()
	{
		$cate = Db::table('systematics')->where('title','首饰')->find();
		$cate2 = Db::table('systematics')->where(['type'=>2, 'superior_id'=> $cate['id']])->select();

		$contents = ['JUSTE UN CLOU系列','AMULETTE DE CARTIER系列','LOVE系列','PANTHèRE DE CARTIER系列','TRINITY系列','CACTUS DE CARTIER 系列','钻石系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '卡地亚/Cartier'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['仲夏夜之梦','双年展戒指','Hyd&ocircr','Tellus','Aeros','Héphaistos','东方花园系列','浪漫英式花园系列','浩瀚星空系列','芭蕾系列','中国红限量系列','Effeuillage系列','情人节系列','四叶草Alhambra系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '梵克雅宝/Van Cleef & Arpels/VCA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['SERPENTI系列','BVLGARI BVLGARI系列','DIVA系列','B.ZERO1系列','MVSA系列','MONETE系列','PARENTESI系列','SAVE THE CHILDREN系列','SAPPHIRE FLOWER系列','INTARSIO系列','ALLEGRA系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '宝格丽/BVLGARI'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}


		$contents = ['Tiffany HardWear','Tiffany T','Tiffany Keys','Return to Tiffany 系列','Tiffany 1837 系列','Tiffany Infinity','Tiffany Victoria','Atlas系列','Tiffany Soleste','蒂芙尼黄钻','Tiffany Metro','Tiffany Bow','ATLAS系列','Tiffany East West','Tiffany Cocktail Watch系列','TIFFANY CT60系列'];
		$cate3 = Db::table('systematics')->where(['type'=>3, 'title'=> '蒂芙尼/Tiffany & Co爱思卡达/ESCADA'])->select();
		foreach ($contents as $content) {
			foreach ($cate2 as $c2) {
			foreach ($cate3 as $c3) {
				Db::table('systematics')->insert(['superior_id'=>$c3['id'], 'superior_gene' => $cate['id'].'-'.$c2['id'].'-'.$c3['id'], 'type' => 4,'state'=>0, 'title'=> $content,'createtime'=>date('Y-m-d H:i:s'), 'system_id'=>1] );
			}
		}
		}
	}
	
}